IF EXISTS(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('Usp_ShoppingCartDelete') AND o.[type]=N'P')
BEGIN
	DROP PROC Usp_ShoppingCartDelete
END
GO
CREATE PROCEDURE  Usp_ShoppingCartDelete(
	@MemLoginID NVARCHAR(50),
	@ProductGuid UNIQUEIDENTIFIER
)	
AS 
		BEGIN
			DELETE FROM ShopNum1_Cart
			WHERE 
				MemLoginID=@MemLoginID AND ProductGuid=@ProductGuid
		END
	